Edinburgh’s road network
Edinburgh’s control zones
Time series analysis
Mapping accidents with roads: 2013
## LAYER Accident_Index
## 1 20mph existing streets 111
## 2 20mph local streets 156
## 3 20mph main streets 388
## 4 30mph 231
## 5 40mph 92
## 6 50, 60 or 70mph 4
## 7 Part time 20mph 7
## 8 Trunk roads 3
## Speed_limit Accident_Index
## 1 20 40
## 2 30 868
## 3 40 84
Mapping accidents with roads: 2014
## LAYER Accident_Index
## 1 20mph existing streets 308
## 2 20mph local streets 316
## 3 20mph main streets 778
## 4 30mph 532
## 5 40mph 136
## 6 50, 60 or 70mph 28
## 7 Part time 20mph 18
## 8 Trunk roads 10
## Speed_limit Accident_Index
## 1 20 78
## 2 30 1910
## 3 40 138
Mapping accidents with roads: 2015
## LAYER Accident_Index
## 1 20mph existing streets 106
## 2 20mph local streets 156
## 3 20mph main streets 327
## 4 30mph 254
## 5 40mph 80
## 6 50, 60 or 70mph 12
## 7 Part time 20mph 6
## 8 Trunk roads 5
## Speed_limit Accident_Index
## 1 20 34
## 2 30 832
## 3 40 80
Mapping accidents with roads: 2018
## LAYER Accident_Index
## 1 20mph existing streets 74
## 2 20mph local streets 102
## 3 20mph main streets 220
## 4 30mph 175
## 5 40mph 52
## 6 50, 60 or 70mph 6
## 7 Part time 20mph 9
## 8 Trunk roads 2
## Speed_limit Accident_Index
## 1 20 351
## 2 30 230
## 3 40 59
Count pre 20mph
## LAYER Accident_Index
## 1 20mph existing streets 525
## 2 20mph local streets 628
## 3 20mph main streets 1493
## 4 30mph 1017
## 5 40mph 308
## 6 50, 60 or 70mph 44
## 7 Part time 20mph 31
## 8 Trunk roads 18
## Speed_limit Accident_Index
## 1 20 152
## 2 30 3610
## 3 40 302
Count post 20mph
## LAYER Accident_Index
## 1 20mph existing streets 74
## 2 20mph local streets 102
## 3 20mph main streets 220
## 4 30mph 175
## 5 40mph 52
## 6 50, 60 or 70mph 6
## 7 Part time 20mph 9
## 8 Trunk roads 2
## Speed_limit Accident_Index
## 1 20 351
## 2 30 230
## 3 40 59
Output column: Layer
## Accident_Index Speed_limit LAYER
## 1 2014950003991 30 20mph existing streets
## 2 2014950003991 30 20mph existing streets
## 3 2018950000480 30 20mph existing streets
## 4 2015950005695 30 20mph existing streets
## 5 2013950004051 20 20mph existing streets
## 6 2015950004165 30 20mph existing streets
Mapping accidents with zones: 2013
Mapping accidents with zones: 2014
Mapping accidents with zones: 2015
Mapping accidents with zones: 2018
Output column: Implementation Zone
## Accident_Index Speed_limit ImplementationZone
## 1 2013950000001 30 1
## 2 2013950000002 30 2
## 3 2013950000003 30 2
## 4 2013950000007 30 1
## 5 2013950000010 30 4
## 6 2013950000030 30 2